package com.swt.draw.example;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class GztToolExample {
    protected String orderByClause;

    protected boolean distinct;

    protected int offset;

    protected int limit;

    protected boolean page;

    protected List<Criteria> oredCriteria;

    public GztToolExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public int getOffset() {
        return offset;
    }

    public void setOffset(int offset) {
        this.offset = offset;
    }

    public int getLimit() {
        return limit;
    }

    public void setLimit(int limit) {
        this.limit = limit;
    }

    public boolean isPage() {
        return page;
    }

    public void setPage(boolean page) {
        this.page = page;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andJhIsNull() {
            addCriterion("JH is null");
            return (Criteria) this;
        }

        public Criteria andJhIsNotNull() {
            addCriterion("JH is not null");
            return (Criteria) this;
        }

        public Criteria andJhEqualTo(String value) {
            addCriterion("JH =", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhNotEqualTo(String value) {
            addCriterion("JH <>", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhGreaterThan(String value) {
            addCriterion("JH >", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhGreaterThanOrEqualTo(String value) {
            addCriterion("JH >=", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhLessThan(String value) {
            addCriterion("JH <", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhLessThanOrEqualTo(String value) {
            addCriterion("JH <=", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhLike(String value) {
            addCriterion("JH like", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhNotLike(String value) {
            addCriterion("JH not like", value, "jh");
            return (Criteria) this;
        }

        public Criteria andJhIn(List<String> values) {
            addCriterion("JH in", values, "jh");
            return (Criteria) this;
        }

        public Criteria andJhNotIn(List<String> values) {
            addCriterion("JH not in", values, "jh");
            return (Criteria) this;
        }

        public Criteria andJhBetween(String value1, String value2) {
            addCriterion("JH between", value1, value2, "jh");
            return (Criteria) this;
        }

        public Criteria andJhNotBetween(String value1, String value2) {
            addCriterion("JH not between", value1, value2, "jh");
            return (Criteria) this;
        }

        public Criteria andLbIsNull() {
            addCriterion("LB is null");
            return (Criteria) this;
        }

        public Criteria andLbIsNotNull() {
            addCriterion("LB is not null");
            return (Criteria) this;
        }

        public Criteria andLbEqualTo(String value) {
            addCriterion("LB =", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbNotEqualTo(String value) {
            addCriterion("LB <>", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbGreaterThan(String value) {
            addCriterion("LB >", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbGreaterThanOrEqualTo(String value) {
            addCriterion("LB >=", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbLessThan(String value) {
            addCriterion("LB <", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbLessThanOrEqualTo(String value) {
            addCriterion("LB <=", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbLike(String value) {
            addCriterion("LB like", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbNotLike(String value) {
            addCriterion("LB not like", value, "lb");
            return (Criteria) this;
        }

        public Criteria andLbIn(List<String> values) {
            addCriterion("LB in", values, "lb");
            return (Criteria) this;
        }

        public Criteria andLbNotIn(List<String> values) {
            addCriterion("LB not in", values, "lb");
            return (Criteria) this;
        }

        public Criteria andLbBetween(String value1, String value2) {
            addCriterion("LB between", value1, value2, "lb");
            return (Criteria) this;
        }

        public Criteria andLbNotBetween(String value1, String value2) {
            addCriterion("LB not between", value1, value2, "lb");
            return (Criteria) this;
        }

        public Criteria andGjmcIsNull() {
            addCriterion("GJMC is null");
            return (Criteria) this;
        }

        public Criteria andGjmcIsNotNull() {
            addCriterion("GJMC is not null");
            return (Criteria) this;
        }

        public Criteria andGjmcEqualTo(String value) {
            addCriterion("GJMC =", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcNotEqualTo(String value) {
            addCriterion("GJMC <>", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcGreaterThan(String value) {
            addCriterion("GJMC >", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcGreaterThanOrEqualTo(String value) {
            addCriterion("GJMC >=", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcLessThan(String value) {
            addCriterion("GJMC <", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcLessThanOrEqualTo(String value) {
            addCriterion("GJMC <=", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcLike(String value) {
            addCriterion("GJMC like", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcNotLike(String value) {
            addCriterion("GJMC not like", value, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcIn(List<String> values) {
            addCriterion("GJMC in", values, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcNotIn(List<String> values) {
            addCriterion("GJMC not in", values, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcBetween(String value1, String value2) {
            addCriterion("GJMC between", value1, value2, "gjmc");
            return (Criteria) this;
        }

        public Criteria andGjmcNotBetween(String value1, String value2) {
            addCriterion("GJMC not between", value1, value2, "gjmc");
            return (Criteria) this;
        }

        public Criteria andSjrqIsNull() {
            addCriterion("SJRQ is null");
            return (Criteria) this;
        }

        public Criteria andSjrqIsNotNull() {
            addCriterion("SJRQ is not null");
            return (Criteria) this;
        }

        public Criteria andSjrqEqualTo(Date value) {
            addCriterion("SJRQ =", value, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqNotEqualTo(Date value) {
            addCriterion("SJRQ <>", value, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqGreaterThan(Date value) {
            addCriterion("SJRQ >", value, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqGreaterThanOrEqualTo(Date value) {
            addCriterion("SJRQ >=", value, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqLessThan(Date value) {
            addCriterion("SJRQ <", value, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqLessThanOrEqualTo(Date value) {
            addCriterion("SJRQ <=", value, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqIn(List<Date> values) {
            addCriterion("SJRQ in", values, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqNotIn(List<Date> values) {
            addCriterion("SJRQ not in", values, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqBetween(Date value1, Date value2) {
            addCriterion("SJRQ between", value1, value2, "sjrq");
            return (Criteria) this;
        }

        public Criteria andSjrqNotBetween(Date value1, Date value2) {
            addCriterion("SJRQ not between", value1, value2, "sjrq");
            return (Criteria) this;
        }

        public Criteria andBiaozhiIsNull() {
            addCriterion("BIAOZHI is null");
            return (Criteria) this;
        }

        public Criteria andBiaozhiIsNotNull() {
            addCriterion("BIAOZHI is not null");
            return (Criteria) this;
        }

        public Criteria andBiaozhiEqualTo(String value) {
            addCriterion("BIAOZHI =", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiNotEqualTo(String value) {
            addCriterion("BIAOZHI <>", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiGreaterThan(String value) {
            addCriterion("BIAOZHI >", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiGreaterThanOrEqualTo(String value) {
            addCriterion("BIAOZHI >=", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiLessThan(String value) {
            addCriterion("BIAOZHI <", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiLessThanOrEqualTo(String value) {
            addCriterion("BIAOZHI <=", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiLike(String value) {
            addCriterion("BIAOZHI like", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiNotLike(String value) {
            addCriterion("BIAOZHI not like", value, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiIn(List<String> values) {
            addCriterion("BIAOZHI in", values, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiNotIn(List<String> values) {
            addCriterion("BIAOZHI not in", values, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiBetween(String value1, String value2) {
            addCriterion("BIAOZHI between", value1, value2, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andBiaozhiNotBetween(String value1, String value2) {
            addCriterion("BIAOZHI not between", value1, value2, "biaozhi");
            return (Criteria) this;
        }

        public Criteria andDepthIsNull() {
            addCriterion("DEPTH is null");
            return (Criteria) this;
        }

        public Criteria andDepthIsNotNull() {
            addCriterion("DEPTH is not null");
            return (Criteria) this;
        }

        public Criteria andDepthEqualTo(BigDecimal value) {
            addCriterion("DEPTH =", value, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthNotEqualTo(BigDecimal value) {
            addCriterion("DEPTH <>", value, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthGreaterThan(BigDecimal value) {
            addCriterion("DEPTH >", value, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DEPTH >=", value, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthLessThan(BigDecimal value) {
            addCriterion("DEPTH <", value, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DEPTH <=", value, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthIn(List<BigDecimal> values) {
            addCriterion("DEPTH in", values, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthNotIn(List<BigDecimal> values) {
            addCriterion("DEPTH not in", values, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEPTH between", value1, value2, "depth");
            return (Criteria) this;
        }

        public Criteria andDepthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEPTH not between", value1, value2, "depth");
            return (Criteria) this;
        }

        public Criteria andUpposIsNull() {
            addCriterion("UPPOS is null");
            return (Criteria) this;
        }

        public Criteria andUpposIsNotNull() {
            addCriterion("UPPOS is not null");
            return (Criteria) this;
        }

        public Criteria andUpposEqualTo(BigDecimal value) {
            addCriterion("UPPOS =", value, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposNotEqualTo(BigDecimal value) {
            addCriterion("UPPOS <>", value, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposGreaterThan(BigDecimal value) {
            addCriterion("UPPOS >", value, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UPPOS >=", value, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposLessThan(BigDecimal value) {
            addCriterion("UPPOS <", value, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UPPOS <=", value, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposIn(List<BigDecimal> values) {
            addCriterion("UPPOS in", values, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposNotIn(List<BigDecimal> values) {
            addCriterion("UPPOS not in", values, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPPOS between", value1, value2, "uppos");
            return (Criteria) this;
        }

        public Criteria andUpposNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPPOS not between", value1, value2, "uppos");
            return (Criteria) this;
        }

        public Criteria andWradiousIsNull() {
            addCriterion("WRADIOUS is null");
            return (Criteria) this;
        }

        public Criteria andWradiousIsNotNull() {
            addCriterion("WRADIOUS is not null");
            return (Criteria) this;
        }

        public Criteria andWradiousEqualTo(BigDecimal value) {
            addCriterion("WRADIOUS =", value, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousNotEqualTo(BigDecimal value) {
            addCriterion("WRADIOUS <>", value, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousGreaterThan(BigDecimal value) {
            addCriterion("WRADIOUS >", value, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WRADIOUS >=", value, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousLessThan(BigDecimal value) {
            addCriterion("WRADIOUS <", value, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WRADIOUS <=", value, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousIn(List<BigDecimal> values) {
            addCriterion("WRADIOUS in", values, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousNotIn(List<BigDecimal> values) {
            addCriterion("WRADIOUS not in", values, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WRADIOUS between", value1, value2, "wradious");
            return (Criteria) this;
        }

        public Criteria andWradiousNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WRADIOUS not between", value1, value2, "wradious");
            return (Criteria) this;
        }

        public Criteria andDownposIsNull() {
            addCriterion("DOWNPOS is null");
            return (Criteria) this;
        }

        public Criteria andDownposIsNotNull() {
            addCriterion("DOWNPOS is not null");
            return (Criteria) this;
        }

        public Criteria andDownposEqualTo(BigDecimal value) {
            addCriterion("DOWNPOS =", value, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposNotEqualTo(BigDecimal value) {
            addCriterion("DOWNPOS <>", value, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposGreaterThan(BigDecimal value) {
            addCriterion("DOWNPOS >", value, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNPOS >=", value, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposLessThan(BigDecimal value) {
            addCriterion("DOWNPOS <", value, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNPOS <=", value, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposIn(List<BigDecimal> values) {
            addCriterion("DOWNPOS in", values, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposNotIn(List<BigDecimal> values) {
            addCriterion("DOWNPOS not in", values, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNPOS between", value1, value2, "downpos");
            return (Criteria) this;
        }

        public Criteria andDownposNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNPOS not between", value1, value2, "downpos");
            return (Criteria) this;
        }

        public Criteria andBzIsNull() {
            addCriterion("BZ is null");
            return (Criteria) this;
        }

        public Criteria andBzIsNotNull() {
            addCriterion("BZ is not null");
            return (Criteria) this;
        }

        public Criteria andBzEqualTo(String value) {
            addCriterion("BZ =", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotEqualTo(String value) {
            addCriterion("BZ <>", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzGreaterThan(String value) {
            addCriterion("BZ >", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzGreaterThanOrEqualTo(String value) {
            addCriterion("BZ >=", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLessThan(String value) {
            addCriterion("BZ <", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLessThanOrEqualTo(String value) {
            addCriterion("BZ <=", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLike(String value) {
            addCriterion("BZ like", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotLike(String value) {
            addCriterion("BZ not like", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzIn(List<String> values) {
            addCriterion("BZ in", values, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotIn(List<String> values) {
            addCriterion("BZ not in", values, "bz");
            return (Criteria) this;
        }

        public Criteria andBzBetween(String value1, String value2) {
            addCriterion("BZ between", value1, value2, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotBetween(String value1, String value2) {
            addCriterion("BZ not between", value1, value2, "bz");
            return (Criteria) this;
        }

        public Criteria andDownnullIsNull() {
            addCriterion("DOWNNULL is null");
            return (Criteria) this;
        }

        public Criteria andDownnullIsNotNull() {
            addCriterion("DOWNNULL is not null");
            return (Criteria) this;
        }

        public Criteria andDownnullEqualTo(BigDecimal value) {
            addCriterion("DOWNNULL =", value, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullNotEqualTo(BigDecimal value) {
            addCriterion("DOWNNULL <>", value, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullGreaterThan(BigDecimal value) {
            addCriterion("DOWNNULL >", value, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNNULL >=", value, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullLessThan(BigDecimal value) {
            addCriterion("DOWNNULL <", value, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DOWNNULL <=", value, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullIn(List<BigDecimal> values) {
            addCriterion("DOWNNULL in", values, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullNotIn(List<BigDecimal> values) {
            addCriterion("DOWNNULL not in", values, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNNULL between", value1, value2, "downnull");
            return (Criteria) this;
        }

        public Criteria andDownnullNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DOWNNULL not between", value1, value2, "downnull");
            return (Criteria) this;
        }

        public Criteria andDesigntypeIsNull() {
            addCriterion("DESIGNTYPE is null");
            return (Criteria) this;
        }

        public Criteria andDesigntypeIsNotNull() {
            addCriterion("DESIGNTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDesigntypeEqualTo(String value) {
            addCriterion("DESIGNTYPE =", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeNotEqualTo(String value) {
            addCriterion("DESIGNTYPE <>", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeGreaterThan(String value) {
            addCriterion("DESIGNTYPE >", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeGreaterThanOrEqualTo(String value) {
            addCriterion("DESIGNTYPE >=", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeLessThan(String value) {
            addCriterion("DESIGNTYPE <", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeLessThanOrEqualTo(String value) {
            addCriterion("DESIGNTYPE <=", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeLike(String value) {
            addCriterion("DESIGNTYPE like", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeNotLike(String value) {
            addCriterion("DESIGNTYPE not like", value, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeIn(List<String> values) {
            addCriterion("DESIGNTYPE in", values, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeNotIn(List<String> values) {
            addCriterion("DESIGNTYPE not in", values, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeBetween(String value1, String value2) {
            addCriterion("DESIGNTYPE between", value1, value2, "designtype");
            return (Criteria) this;
        }

        public Criteria andDesigntypeNotBetween(String value1, String value2) {
            addCriterion("DESIGNTYPE not between", value1, value2, "designtype");
            return (Criteria) this;
        }

        public Criteria andDmIsNull() {
            addCriterion("DM is null");
            return (Criteria) this;
        }

        public Criteria andDmIsNotNull() {
            addCriterion("DM is not null");
            return (Criteria) this;
        }

        public Criteria andDmEqualTo(String value) {
            addCriterion("DM =", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmNotEqualTo(String value) {
            addCriterion("DM <>", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmGreaterThan(String value) {
            addCriterion("DM >", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmGreaterThanOrEqualTo(String value) {
            addCriterion("DM >=", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmLessThan(String value) {
            addCriterion("DM <", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmLessThanOrEqualTo(String value) {
            addCriterion("DM <=", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmLike(String value) {
            addCriterion("DM like", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmNotLike(String value) {
            addCriterion("DM not like", value, "dm");
            return (Criteria) this;
        }

        public Criteria andDmIn(List<String> values) {
            addCriterion("DM in", values, "dm");
            return (Criteria) this;
        }

        public Criteria andDmNotIn(List<String> values) {
            addCriterion("DM not in", values, "dm");
            return (Criteria) this;
        }

        public Criteria andDmBetween(String value1, String value2) {
            addCriterion("DM between", value1, value2, "dm");
            return (Criteria) this;
        }

        public Criteria andDmNotBetween(String value1, String value2) {
            addCriterion("DM not between", value1, value2, "dm");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightIsNull() {
            addCriterion("BIAOZHUHEIGHT is null");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightIsNotNull() {
            addCriterion("BIAOZHUHEIGHT is not null");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightEqualTo(Short value) {
            addCriterion("BIAOZHUHEIGHT =", value, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightNotEqualTo(Short value) {
            addCriterion("BIAOZHUHEIGHT <>", value, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightGreaterThan(Short value) {
            addCriterion("BIAOZHUHEIGHT >", value, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightGreaterThanOrEqualTo(Short value) {
            addCriterion("BIAOZHUHEIGHT >=", value, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightLessThan(Short value) {
            addCriterion("BIAOZHUHEIGHT <", value, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightLessThanOrEqualTo(Short value) {
            addCriterion("BIAOZHUHEIGHT <=", value, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightIn(List<Short> values) {
            addCriterion("BIAOZHUHEIGHT in", values, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightNotIn(List<Short> values) {
            addCriterion("BIAOZHUHEIGHT not in", values, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightBetween(Short value1, Short value2) {
            addCriterion("BIAOZHUHEIGHT between", value1, value2, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuheightNotBetween(Short value1, Short value2) {
            addCriterion("BIAOZHUHEIGHT not between", value1, value2, "biaozhuheight");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthIsNull() {
            addCriterion("BIAOZHUWIDTH is null");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthIsNotNull() {
            addCriterion("BIAOZHUWIDTH is not null");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthEqualTo(BigDecimal value) {
            addCriterion("BIAOZHUWIDTH =", value, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthNotEqualTo(BigDecimal value) {
            addCriterion("BIAOZHUWIDTH <>", value, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthGreaterThan(BigDecimal value) {
            addCriterion("BIAOZHUWIDTH >", value, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BIAOZHUWIDTH >=", value, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthLessThan(BigDecimal value) {
            addCriterion("BIAOZHUWIDTH <", value, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BIAOZHUWIDTH <=", value, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthIn(List<BigDecimal> values) {
            addCriterion("BIAOZHUWIDTH in", values, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthNotIn(List<BigDecimal> values) {
            addCriterion("BIAOZHUWIDTH not in", values, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BIAOZHUWIDTH between", value1, value2, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andBiaozhuwidthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BIAOZHUWIDTH not between", value1, value2, "biaozhuwidth");
            return (Criteria) this;
        }

        public Criteria andXlocationIsNull() {
            addCriterion("XLOCATION is null");
            return (Criteria) this;
        }

        public Criteria andXlocationIsNotNull() {
            addCriterion("XLOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andXlocationEqualTo(BigDecimal value) {
            addCriterion("XLOCATION =", value, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationNotEqualTo(BigDecimal value) {
            addCriterion("XLOCATION <>", value, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationGreaterThan(BigDecimal value) {
            addCriterion("XLOCATION >", value, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("XLOCATION >=", value, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationLessThan(BigDecimal value) {
            addCriterion("XLOCATION <", value, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationLessThanOrEqualTo(BigDecimal value) {
            addCriterion("XLOCATION <=", value, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationIn(List<BigDecimal> values) {
            addCriterion("XLOCATION in", values, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationNotIn(List<BigDecimal> values) {
            addCriterion("XLOCATION not in", values, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("XLOCATION between", value1, value2, "xlocation");
            return (Criteria) this;
        }

        public Criteria andXlocationNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("XLOCATION not between", value1, value2, "xlocation");
            return (Criteria) this;
        }

        public Criteria andYlocationIsNull() {
            addCriterion("YLOCATION is null");
            return (Criteria) this;
        }

        public Criteria andYlocationIsNotNull() {
            addCriterion("YLOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andYlocationEqualTo(BigDecimal value) {
            addCriterion("YLOCATION =", value, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationNotEqualTo(BigDecimal value) {
            addCriterion("YLOCATION <>", value, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationGreaterThan(BigDecimal value) {
            addCriterion("YLOCATION >", value, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YLOCATION >=", value, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationLessThan(BigDecimal value) {
            addCriterion("YLOCATION <", value, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YLOCATION <=", value, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationIn(List<BigDecimal> values) {
            addCriterion("YLOCATION in", values, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationNotIn(List<BigDecimal> values) {
            addCriterion("YLOCATION not in", values, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YLOCATION between", value1, value2, "ylocation");
            return (Criteria) this;
        }

        public Criteria andYlocationNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YLOCATION not between", value1, value2, "ylocation");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("USERID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("USERID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("USERID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("USERID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("USERID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("USERID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("USERID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("USERID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("USERID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("USERID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("USERID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("USERID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("USERID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("USERID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andDwmcIsNull() {
            addCriterion("DWMC is null");
            return (Criteria) this;
        }

        public Criteria andDwmcIsNotNull() {
            addCriterion("DWMC is not null");
            return (Criteria) this;
        }

        public Criteria andDwmcEqualTo(String value) {
            addCriterion("DWMC =", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotEqualTo(String value) {
            addCriterion("DWMC <>", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcGreaterThan(String value) {
            addCriterion("DWMC >", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcGreaterThanOrEqualTo(String value) {
            addCriterion("DWMC >=", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcLessThan(String value) {
            addCriterion("DWMC <", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcLessThanOrEqualTo(String value) {
            addCriterion("DWMC <=", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcLike(String value) {
            addCriterion("DWMC like", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotLike(String value) {
            addCriterion("DWMC not like", value, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcIn(List<String> values) {
            addCriterion("DWMC in", values, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotIn(List<String> values) {
            addCriterion("DWMC not in", values, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcBetween(String value1, String value2) {
            addCriterion("DWMC between", value1, value2, "dwmc");
            return (Criteria) this;
        }

        public Criteria andDwmcNotBetween(String value1, String value2) {
            addCriterion("DWMC not between", value1, value2, "dwmc");
            return (Criteria) this;
        }

        public Criteria andXchangeIsNull() {
            addCriterion("XCHANGE is null");
            return (Criteria) this;
        }

        public Criteria andXchangeIsNotNull() {
            addCriterion("XCHANGE is not null");
            return (Criteria) this;
        }

        public Criteria andXchangeEqualTo(BigDecimal value) {
            addCriterion("XCHANGE =", value, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeNotEqualTo(BigDecimal value) {
            addCriterion("XCHANGE <>", value, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeGreaterThan(BigDecimal value) {
            addCriterion("XCHANGE >", value, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("XCHANGE >=", value, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeLessThan(BigDecimal value) {
            addCriterion("XCHANGE <", value, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("XCHANGE <=", value, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeIn(List<BigDecimal> values) {
            addCriterion("XCHANGE in", values, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeNotIn(List<BigDecimal> values) {
            addCriterion("XCHANGE not in", values, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("XCHANGE between", value1, value2, "xchange");
            return (Criteria) this;
        }

        public Criteria andXchangeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("XCHANGE not between", value1, value2, "xchange");
            return (Criteria) this;
        }

        public Criteria andYchangeIsNull() {
            addCriterion("YCHANGE is null");
            return (Criteria) this;
        }

        public Criteria andYchangeIsNotNull() {
            addCriterion("YCHANGE is not null");
            return (Criteria) this;
        }

        public Criteria andYchangeEqualTo(BigDecimal value) {
            addCriterion("YCHANGE =", value, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeNotEqualTo(BigDecimal value) {
            addCriterion("YCHANGE <>", value, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeGreaterThan(BigDecimal value) {
            addCriterion("YCHANGE >", value, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("YCHANGE >=", value, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeLessThan(BigDecimal value) {
            addCriterion("YCHANGE <", value, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("YCHANGE <=", value, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeIn(List<BigDecimal> values) {
            addCriterion("YCHANGE in", values, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeNotIn(List<BigDecimal> values) {
            addCriterion("YCHANGE not in", values, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YCHANGE between", value1, value2, "ychange");
            return (Criteria) this;
        }

        public Criteria andYchangeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("YCHANGE not between", value1, value2, "ychange");
            return (Criteria) this;
        }

        public Criteria andBelongIsNull() {
            addCriterion("BELONG is null");
            return (Criteria) this;
        }

        public Criteria andBelongIsNotNull() {
            addCriterion("BELONG is not null");
            return (Criteria) this;
        }

        public Criteria andBelongEqualTo(String value) {
            addCriterion("BELONG =", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotEqualTo(String value) {
            addCriterion("BELONG <>", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongGreaterThan(String value) {
            addCriterion("BELONG >", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongGreaterThanOrEqualTo(String value) {
            addCriterion("BELONG >=", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongLessThan(String value) {
            addCriterion("BELONG <", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongLessThanOrEqualTo(String value) {
            addCriterion("BELONG <=", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongLike(String value) {
            addCriterion("BELONG like", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotLike(String value) {
            addCriterion("BELONG not like", value, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongIn(List<String> values) {
            addCriterion("BELONG in", values, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotIn(List<String> values) {
            addCriterion("BELONG not in", values, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongBetween(String value1, String value2) {
            addCriterion("BELONG between", value1, value2, "belong");
            return (Criteria) this;
        }

        public Criteria andBelongNotBetween(String value1, String value2) {
            addCriterion("BELONG not between", value1, value2, "belong");
            return (Criteria) this;
        }

        public Criteria andFenzhiIsNull() {
            addCriterion("FENZHI is null");
            return (Criteria) this;
        }

        public Criteria andFenzhiIsNotNull() {
            addCriterion("FENZHI is not null");
            return (Criteria) this;
        }

        public Criteria andFenzhiEqualTo(String value) {
            addCriterion("FENZHI =", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiNotEqualTo(String value) {
            addCriterion("FENZHI <>", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiGreaterThan(String value) {
            addCriterion("FENZHI >", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiGreaterThanOrEqualTo(String value) {
            addCriterion("FENZHI >=", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiLessThan(String value) {
            addCriterion("FENZHI <", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiLessThanOrEqualTo(String value) {
            addCriterion("FENZHI <=", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiLike(String value) {
            addCriterion("FENZHI like", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiNotLike(String value) {
            addCriterion("FENZHI not like", value, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiIn(List<String> values) {
            addCriterion("FENZHI in", values, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiNotIn(List<String> values) {
            addCriterion("FENZHI not in", values, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiBetween(String value1, String value2) {
            addCriterion("FENZHI between", value1, value2, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andFenzhiNotBetween(String value1, String value2) {
            addCriterion("FENZHI not between", value1, value2, "fenzhi");
            return (Criteria) this;
        }

        public Criteria andYendIsNull() {
            addCriterion("YEND is null");
            return (Criteria) this;
        }

        public Criteria andYendIsNotNull() {
            addCriterion("YEND is not null");
            return (Criteria) this;
        }

        public Criteria andYendEqualTo(String value) {
            addCriterion("YEND =", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendNotEqualTo(String value) {
            addCriterion("YEND <>", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendGreaterThan(String value) {
            addCriterion("YEND >", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendGreaterThanOrEqualTo(String value) {
            addCriterion("YEND >=", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendLessThan(String value) {
            addCriterion("YEND <", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendLessThanOrEqualTo(String value) {
            addCriterion("YEND <=", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendLike(String value) {
            addCriterion("YEND like", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendNotLike(String value) {
            addCriterion("YEND not like", value, "yend");
            return (Criteria) this;
        }

        public Criteria andYendIn(List<String> values) {
            addCriterion("YEND in", values, "yend");
            return (Criteria) this;
        }

        public Criteria andYendNotIn(List<String> values) {
            addCriterion("YEND not in", values, "yend");
            return (Criteria) this;
        }

        public Criteria andYendBetween(String value1, String value2) {
            addCriterion("YEND between", value1, value2, "yend");
            return (Criteria) this;
        }

        public Criteria andYendNotBetween(String value1, String value2) {
            addCriterion("YEND not between", value1, value2, "yend");
            return (Criteria) this;
        }

        public Criteria andGjpdIsNull() {
            addCriterion("GJPD is null");
            return (Criteria) this;
        }

        public Criteria andGjpdIsNotNull() {
            addCriterion("GJPD is not null");
            return (Criteria) this;
        }

        public Criteria andGjpdEqualTo(String value) {
            addCriterion("GJPD =", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdNotEqualTo(String value) {
            addCriterion("GJPD <>", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdGreaterThan(String value) {
            addCriterion("GJPD >", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdGreaterThanOrEqualTo(String value) {
            addCriterion("GJPD >=", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdLessThan(String value) {
            addCriterion("GJPD <", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdLessThanOrEqualTo(String value) {
            addCriterion("GJPD <=", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdLike(String value) {
            addCriterion("GJPD like", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdNotLike(String value) {
            addCriterion("GJPD not like", value, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdIn(List<String> values) {
            addCriterion("GJPD in", values, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdNotIn(List<String> values) {
            addCriterion("GJPD not in", values, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdBetween(String value1, String value2) {
            addCriterion("GJPD between", value1, value2, "gjpd");
            return (Criteria) this;
        }

        public Criteria andGjpdNotBetween(String value1, String value2) {
            addCriterion("GJPD not between", value1, value2, "gjpd");
            return (Criteria) this;
        }

        public Criteria andColumn1IsNull() {
            addCriterion("COLUMN1 is null");
            return (Criteria) this;
        }

        public Criteria andColumn1IsNotNull() {
            addCriterion("COLUMN1 is not null");
            return (Criteria) this;
        }

        public Criteria andColumn1EqualTo(String value) {
            addCriterion("COLUMN1 =", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1NotEqualTo(String value) {
            addCriterion("COLUMN1 <>", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1GreaterThan(String value) {
            addCriterion("COLUMN1 >", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1GreaterThanOrEqualTo(String value) {
            addCriterion("COLUMN1 >=", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1LessThan(String value) {
            addCriterion("COLUMN1 <", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1LessThanOrEqualTo(String value) {
            addCriterion("COLUMN1 <=", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1Like(String value) {
            addCriterion("COLUMN1 like", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1NotLike(String value) {
            addCriterion("COLUMN1 not like", value, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1In(List<String> values) {
            addCriterion("COLUMN1 in", values, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1NotIn(List<String> values) {
            addCriterion("COLUMN1 not in", values, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1Between(String value1, String value2) {
            addCriterion("COLUMN1 between", value1, value2, "column1");
            return (Criteria) this;
        }

        public Criteria andColumn1NotBetween(String value1, String value2) {
            addCriterion("COLUMN1 not between", value1, value2, "column1");
            return (Criteria) this;
        }

        public Criteria andCdIsNull() {
            addCriterion("CD is null");
            return (Criteria) this;
        }

        public Criteria andCdIsNotNull() {
            addCriterion("CD is not null");
            return (Criteria) this;
        }

        public Criteria andCdEqualTo(String value) {
            addCriterion("CD =", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdNotEqualTo(String value) {
            addCriterion("CD <>", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdGreaterThan(String value) {
            addCriterion("CD >", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdGreaterThanOrEqualTo(String value) {
            addCriterion("CD >=", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdLessThan(String value) {
            addCriterion("CD <", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdLessThanOrEqualTo(String value) {
            addCriterion("CD <=", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdLike(String value) {
            addCriterion("CD like", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdNotLike(String value) {
            addCriterion("CD not like", value, "cd");
            return (Criteria) this;
        }

        public Criteria andCdIn(List<String> values) {
            addCriterion("CD in", values, "cd");
            return (Criteria) this;
        }

        public Criteria andCdNotIn(List<String> values) {
            addCriterion("CD not in", values, "cd");
            return (Criteria) this;
        }

        public Criteria andCdBetween(String value1, String value2) {
            addCriterion("CD between", value1, value2, "cd");
            return (Criteria) this;
        }

        public Criteria andCdNotBetween(String value1, String value2) {
            addCriterion("CD not between", value1, value2, "cd");
            return (Criteria) this;
        }

        public Criteria andDytsbzIsNull() {
            addCriterion("DYTSBZ is null");
            return (Criteria) this;
        }

        public Criteria andDytsbzIsNotNull() {
            addCriterion("DYTSBZ is not null");
            return (Criteria) this;
        }

        public Criteria andDytsbzEqualTo(BigDecimal value) {
            addCriterion("DYTSBZ =", value, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzNotEqualTo(BigDecimal value) {
            addCriterion("DYTSBZ <>", value, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzGreaterThan(BigDecimal value) {
            addCriterion("DYTSBZ >", value, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DYTSBZ >=", value, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzLessThan(BigDecimal value) {
            addCriterion("DYTSBZ <", value, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DYTSBZ <=", value, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzIn(List<BigDecimal> values) {
            addCriterion("DYTSBZ in", values, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzNotIn(List<BigDecimal> values) {
            addCriterion("DYTSBZ not in", values, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DYTSBZ between", value1, value2, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andDytsbzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DYTSBZ not between", value1, value2, "dytsbz");
            return (Criteria) this;
        }

        public Criteria andCsidIsNull() {
            addCriterion("CSID is null");
            return (Criteria) this;
        }

        public Criteria andCsidIsNotNull() {
            addCriterion("CSID is not null");
            return (Criteria) this;
        }

        public Criteria andCsidEqualTo(String value) {
            addCriterion("CSID =", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidNotEqualTo(String value) {
            addCriterion("CSID <>", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidGreaterThan(String value) {
            addCriterion("CSID >", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidGreaterThanOrEqualTo(String value) {
            addCriterion("CSID >=", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidLessThan(String value) {
            addCriterion("CSID <", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidLessThanOrEqualTo(String value) {
            addCriterion("CSID <=", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidLike(String value) {
            addCriterion("CSID like", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidNotLike(String value) {
            addCriterion("CSID not like", value, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidIn(List<String> values) {
            addCriterion("CSID in", values, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidNotIn(List<String> values) {
            addCriterion("CSID not in", values, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidBetween(String value1, String value2) {
            addCriterion("CSID between", value1, value2, "csid");
            return (Criteria) this;
        }

        public Criteria andCsidNotBetween(String value1, String value2) {
            addCriterion("CSID not between", value1, value2, "csid");
            return (Criteria) this;
        }

        public Criteria andSjlxIsNull() {
            addCriterion("SJLX is null");
            return (Criteria) this;
        }

        public Criteria andSjlxIsNotNull() {
            addCriterion("SJLX is not null");
            return (Criteria) this;
        }

        public Criteria andSjlxEqualTo(String value) {
            addCriterion("SJLX =", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxNotEqualTo(String value) {
            addCriterion("SJLX <>", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxGreaterThan(String value) {
            addCriterion("SJLX >", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxGreaterThanOrEqualTo(String value) {
            addCriterion("SJLX >=", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxLessThan(String value) {
            addCriterion("SJLX <", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxLessThanOrEqualTo(String value) {
            addCriterion("SJLX <=", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxLike(String value) {
            addCriterion("SJLX like", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxNotLike(String value) {
            addCriterion("SJLX not like", value, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxIn(List<String> values) {
            addCriterion("SJLX in", values, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxNotIn(List<String> values) {
            addCriterion("SJLX not in", values, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxBetween(String value1, String value2) {
            addCriterion("SJLX between", value1, value2, "sjlx");
            return (Criteria) this;
        }

        public Criteria andSjlxNotBetween(String value1, String value2) {
            addCriterion("SJLX not between", value1, value2, "sjlx");
            return (Criteria) this;
        }

        public Criteria andTgwzIsNull() {
            addCriterion("TGWZ is null");
            return (Criteria) this;
        }

        public Criteria andTgwzIsNotNull() {
            addCriterion("TGWZ is not null");
            return (Criteria) this;
        }

        public Criteria andTgwzEqualTo(String value) {
            addCriterion("TGWZ =", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzNotEqualTo(String value) {
            addCriterion("TGWZ <>", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzGreaterThan(String value) {
            addCriterion("TGWZ >", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzGreaterThanOrEqualTo(String value) {
            addCriterion("TGWZ >=", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzLessThan(String value) {
            addCriterion("TGWZ <", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzLessThanOrEqualTo(String value) {
            addCriterion("TGWZ <=", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzLike(String value) {
            addCriterion("TGWZ like", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzNotLike(String value) {
            addCriterion("TGWZ not like", value, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzIn(List<String> values) {
            addCriterion("TGWZ in", values, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzNotIn(List<String> values) {
            addCriterion("TGWZ not in", values, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzBetween(String value1, String value2) {
            addCriterion("TGWZ between", value1, value2, "tgwz");
            return (Criteria) this;
        }

        public Criteria andTgwzNotBetween(String value1, String value2) {
            addCriterion("TGWZ not between", value1, value2, "tgwz");
            return (Criteria) this;
        }

        public Criteria andGjxhIsNull() {
            addCriterion("GJXH is null");
            return (Criteria) this;
        }

        public Criteria andGjxhIsNotNull() {
            addCriterion("GJXH is not null");
            return (Criteria) this;
        }

        public Criteria andGjxhEqualTo(BigDecimal value) {
            addCriterion("GJXH =", value, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhNotEqualTo(BigDecimal value) {
            addCriterion("GJXH <>", value, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhGreaterThan(BigDecimal value) {
            addCriterion("GJXH >", value, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GJXH >=", value, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhLessThan(BigDecimal value) {
            addCriterion("GJXH <", value, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GJXH <=", value, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhIn(List<BigDecimal> values) {
            addCriterion("GJXH in", values, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhNotIn(List<BigDecimal> values) {
            addCriterion("GJXH not in", values, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GJXH between", value1, value2, "gjxh");
            return (Criteria) this;
        }

        public Criteria andGjxhNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GJXH not between", value1, value2, "gjxh");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
